package com.wms.wms.mapper;

import com.wms.wms.entity.OutStock;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Component;

import java.sql.Date;
import java.util.ArrayList;
import java.util.Collection;
import java.util.List;

@Component
@Mapper
public interface OutStockMapper {
    OutStock selectById(@Param("id") String id);

    List<OutStock> queryListByParam(@Param("id") String id,@Param("b")Date b, @Param("e") Date e,@Param("des") int des);
    Integer queryCountByParam(@Param("id") String id,@Param("b") Date b,@Param("e") Date e,@Param("des") int des);
    Integer queryCountByDate(@Param("b") Date b,@Param("e") Date e,@Param("des") int des);

    double queryTotalById(@Param("id") String id,@Param("b") Date b,@Param("e") Date e);
    double queryTotalByDate(@Param("b") Date b,@Param("e") Date e);


    ArrayList<OutStock> queryByIdAndDate(@Param("id") String id,@Param("b") Date b,@Param("e") Date e,@Param("des") int des);

    ArrayList<OutStock> queryByDate(@Param("id") String id,@Param("b") Date b,@Param("e") Date e,@Param("des") int des);

}

